MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Projects System / Projects (.txt) < prev

Wrap

FileMaker Pro Database | 1996-01-25 | 123KB | 854 lines

Consult ClarisII CLARISII Identification Badges.fp3 IDENTI~1.FP3 HARDDISK \\PAULFARRAH\C CONSULT\ClarisII\v3\Identification Badges.fp3 ..\..\CONSULT\ClarisII\v3\Identification Badges.fp3 C:\CONSULT\ClarisII\v3 HBAM2016AUG95 Pro 3.0 D/8xf1b6aT 6StEUELi8oHh/XmCg3slbN/VP7SdoDa0b9gmGD0GhP7BoZGDh8emxifvTOVz266iY2Bv/65bU/du 2ZLKbt/fv21gKLXl2k2pYa84OZnKFe8a33bvdamBw25xchsqS3WbvHZgeItf0MG5Y6DfH8Wwdf93 /bPRuWN4er/W3uQWbe4Yitjf7Fo7VfsKrlvqUQF+P7Nue/y6xfy6xc+s254V63b9SnWjM/V/qXuv 92taGCuNNxRrT2Mtpy9eVst4bBl63K/h8vMxqt1mrh2CAojIstpd7dduffOeu3qt2vUfnDp8z+Gp ow1PvDoouHzSWd3T5Jage9Zv29aM4nqqwxaug/5plH1ZHTb6dWhr3kMb16rDshbbuGr5V2z4Nir7 skttVO5sve2Xv1lvt+2bvMtrtf3KrFFn+9qh0oxcLYv20BPM/9l6HzUhgz7KcV0v/xru9Wk 4K9XjYuUXJX5m ezd7aDPK0zyfC32ygXJAse1Mim2tw8XxI25x7dLOSJrtTWi+tXHnhfseYkXmsr4GkoEis3d1lW3v in35nnOTgZuv3XTH5maDwN53ehCgej7M9TRFk3q+ZTX8Pe+CGr6Kev3CfbOyRElq/FyusG8HNehw bvvQ7voNpSPBDcmzH1a/eHZz1a+111QJlabD6sdFKPTqfPfc/MKNqmKetfgX9Rf/Yv7iX9xf/LvI X/xT/cU/Xgxs8RcJY/4iYVxVNMBWVUkAtqlKK2C7qrQBaqrSDrhOVTYArlcVHXCDqnQA6qpiAHZQ yeTiYidKt03UO1kZGNq7k+Alx/Cj/xKUPcQ10GU9RP3wG+ASXgVkStkaJaUpJa68YvJ3IK+XUQpJ SteK1csUEUFpZPmaUApLSjeK1cskaZirUYpISr3nROkisUrtopLSD9QoNa9dI6UVWjwmKdUXJ8NN KUWZhrUapfjyt6B57VSm0bEapVZJ6bYapVBTSi1M4xoRvBFNKLVJSntqlNSmlGJMI7UapXZJaXgN HBAM3016AUG95@ be'thB c/e't/e'nA ce'p/teA ce'tD ch/ce'geE cus-te'mB s-/gn ce'p/te c/e't/e'n s-ys-A cus-te'm tre'ck/ng de'te'be's i/e'r be'th pr/c/ng s-uch i/e'cte'rs pre'dD de'te'be'sB e'i/i//cE e'ndA ge'ryD i/e'br/cC i/e'cte'rsD i/e'rB le'unchC le'unch i/e'br/c pre'ductC me'rkB v/ngD pr/c/ngD pre'ductC s-/gnA s-te'b /s-hE s-te'b e'i/i//c ch/ce'geE s-uchD s-ys-tA t/ngB tre'ck/ngB 1990E cus-te'mB cus-te'm tre'ck/ng e&ute'me't/e'nA le'unchC le'unch pr/c/ngD pr/c/ng stre't pre'jE HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 US English - Spelling FileMaker Pro 3.0 Folder pre'j 1990E e&ute'me't/e'nA stre'tD tre'ck/ngB adlingtonD billyD billy adlingtonD emmetC farnsworth johnson loriC emmetC smith BENEFIT RETURN CREATED BY DATE CREATED DATE MODIFIED LAST LAYOUT NOTES PROJECT DESCRIPTION PROJECT FINISH DATE PROJECT ID PROJECT MANAGER PROJECT NAME PROJECT START DATE PROJECT STATUS TOTAL COST Project IDB Project DescriptionB Project NameB Benefit ReturnB Project ManagerB Date CreatedB Date ModifiedB Project StatusB Not Started Total CostB Project Start DateB Project Finish DateB Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12/5/955 NotesB InfoB Created ByB Last LayoutB Description This relational database template consists of the Projects file and the Project Tasks file. These two database files work together to keep track of projects and the specific tasks that need to be accomplished to complete each project. The Projects file keeps track of general information such as project name, status, description, milestones, and resources. The Project Tasks file contains details about the specific tasks, such as the task's status, cost, and headcount. How to u Form View - Tasks A List View Project Report Information Report Menu Form View - Resources and Notes Form View - TasksB A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Status Finish Start Manager Status Finish Start Project Name Enter data for Projects Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Resources & Notes Tasks Projects Tasks File... Project ID Resources & Notes Tasks Projects Tasks File... Project ID Project ReportB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Statusc Finishd Starte Managerf Project Nameg+Click to see more information for a Projectr Infos Closet View As Formu View As Listv Reportsw Recordx Delete Recordy Recordz Your Own Button{ Your Own Button| InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Description Status Finish Start Manager Project Page ## Project Report Close View As View As Reports Your Own Button Tasks Project Report Benefit Return Notes View As View As Reports Your Own Button Tasks Project Report Benefit Return Notes Report MenuB P'Information about the Projects solutionQ Info for this SolutionR InfoS CloseT View As FormU View As ListV ReportsW Your Own Button View As FormU View As ListV ReportsW Your Own Button Your Own ReportI Your Own ReportJ Project ReportK Your Own ReportL>Click on any of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button on any of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button Form View - Resources and NotesB Yesfter Noarter Yesfter Noarter Yesfter Noarter InfoI CloseJ View As FormK View As ListL ReportsM Your Own Button Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter [&Enter Resources and Notes for Projects Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Resources & Notes Tasks Projects Tasks File... Benefit Return Notes Project ID Project Name Project Manager Project Description Start Finish Status 1C>Design and implement new internal capital depreciation system.E Sales AutomationG$Better management of capital assets.H FarnsworthY 10/8/95a On Schedule Develop a customer tracking database for use by both sales and marketing. Multi-user system with local and remote access. Must store in the thousands of records without getting sluggish.E Customer Tracking 90GXIncrease sales by 2.3 million by using current customer list to sell our other products.H JohnsonY 10/8/95a Ahead Launch new tent fabric product.E Launch TimeG!Increase product sales by 15-20%.H Lori EmmetY 10/8/95a Behind 4CXDevelop pricing policy involving such factors as product category, margin, and supplier.E Pricing StrategyG'Attain a standardized pricing strategy.H Billy AdlingtonY 10/8/95a Completed 5CDEstablish 3 new sales offices in Chicago, Boston, and San Francisco.E Site Project 1990G9Increase penetration of these market areas by $1 million.H Smith InfoI CloseJ View As FormK View As ListL ReportsM Your Own Button <2/1/96 Information List View Report Menu Sort by Project Name Sort by Project Start Date Sort by Project Status Project Report Open Script Sort by Project Name Project Report Open Script 10/8/95a On Schedule Information A List View Report Menu Sort by Project Start Date Sort by Project Status Yesfter Noarter <2/1/96 )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E+ ) = 1 Helvetica Geneva Times Times New Roman Arial MS Sans Serif wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw /RPTH FPTHA/SCSI Disk 20:JC:Ken's:COMPAT FUL:Project Tasks MSPCA NAMEA Project Tasks RPTHA Project Tasks .RPTH FPTHA.HARDDISK:CONSULT:ClarisII:v3:Project Tasks.fp3 NAMEA Project Tasks.fp3 RPTHA Project Tasks.fp3 WSPCA C:\CONSULT\ClarisII\v3\ (LIST LISTA0Not Started Ahead On Schedule Behind Completed VDEFA( Project Status List FMRLA Project Tasks ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD 333333 #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,* !$&(265389,#!$$ '275? " $$*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+,)+" &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!PQ 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%&' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGCA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9< 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,027CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 876=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*, 169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,*3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7) !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww pre'j 1990@ Form View - Tasks A List View Project Report Information Report Menu Form View - Resources and Notes Form View - TasksB se this template Start by defining the whole project in the Projects database. Then, name each task and fill out as much of the other information as you know. If you click the arrow button to the right of the task information, the Project Tasks database is opened and brought to the front. Finish filling out the task information, and then click the arrow button to the right of the Project Name to return to the Projects file. How to customize this template You can create custom reports to o Grganize the data. For instance, the report layout included in the Project Tasks file shows the tasks for each person on the team. You might want to organize the tasks by date or status. If you have a regular team, you might want to use a value list to help you enter their names in the Task Manager and Project Manager fields.